/**
 * 
 */
package training;

/**
 * @author Taras
 * 
 */
public class GlobalProperties {

    /**
     * URL JDBC Connection
     */
    public static final String URL = "jdbc:mysql://localhost:3306/";

    /**
     * Database name
     */
    public static final String DB = "noname";

    /**
     * JDBC Driver name
     */
    public static final String DRIVER = "com.mysql.jdbc.Driver";

    /**
     * MySQL User name
     */
    public static final String USER = "root";

    /**
     * MySQL User password
     */
    // public static final String PASS = "";
    public static final String PASS = "";

    /**
     * SQL Command: INSERT into table Users
     */
    public static final String INSERT_USERS = "INSERT INTO "
	    + "Users(ID_Role,Fullname,Login,Password,Email,Date_reg,Activation) "
	    + "VALUES (?,?,?,?,?,?,?);";
    /**
     * SQL Command: INSERT into table Roles
     */
    public static final String INSERT_ROLES = "INSERT INTO Roles(Role) "
	    + "VALUES (?);";
    /**
     * SQL Command: INSERT into table Profiles
     */
    public static final String INSERT_PROFILES = "INSERT "
	    + "INTO Profiles(ID_User,Location,Photo) VALUES (?,?,?);";
    /**
     * SQL Command: SELECT ID User from table Users
     */
    public static final String SELECT_USER = "SELECT ID FROM Users "
	    + "WHERE Login = ? AND Password = ?";
    /**
     * SQL Command: SELECT * from table Profiles
     */
    public static final String SELECT_PROFILES = "SELECT * FROM Profiles "
	    + "WHERE ID_User = ?";
    /**
     * SQL Command: UPDATE * from table Profiles
     */
    public static final String UPDATE_PROFILES = "UPDATE Profiles "
	    + "SET Location = ?, Photo = ? WHERE ID = ?";

}
